
-- =============================================  
-- Author:  Rosario Silva 
-- Create date: 12/09/2012  
-- Description: Verificar si ya existe 
-- la descripcion de un tipo de recurso
-- =============================================  
CREATE PROCEDURE [dbo].[ResourceType_R_CheckName]   
@Id INT, 
@Descripcion NVARCHAR(50)  
AS  
BEGIN  
 SET NOCOUNT ON;  
	SELECT  id 
    FROM TipoRecurso T      
    WHERE T.Activo = 1
    AND descripcion = @Descripcion 
    AND id != @Id
SET NOCOUNT OFF;  
END  

